In other words, you need to know which is the primary key, which is the foreign key, and how tables are connected via these keys.ĭataGrip has a great function for us to look at the overall relationships among all the tables. Next, you want to know how each of the tables in the dataset is connected to each other. Pretty simple to this point, right? EDA and DataGrip is not such a hard thing huh □ 3 Relational Diagram I personally often use this instead of typing SQL syntax: describe table X It’s very handy when you want to quickly check the datatype of all the columns, or copy the list of columns’ names. Simply double-click a table in the Database Explorer in Data Grip, the table opens in the data editor.īonus tip: “Ctrl+B” is the shortcut that gives you the DDL of the table. Now you want to know what the actual data in each table looks like. Now all the dishes are on the table, let’s enjoy our data meals. One more click of the chosen table to see the list of its columns names In DataGrip, you just need to click the small box next to the data source name, choose the schemas that you want to explore, then click refresh. 1 Dataset overviewįirst of all, we need an overview of the dataset that we’re about to work with: a list of tables and views, as well as their columns names. They’re all basic SQL syntax, so if you’re using a different version of the SQL language (MySQL, SQL server, BigQuery, etc.), there would be little or no syntax conversion needed. Note: In this article, I use Snowflake public dataset and Snowflake SQL commands for all SQL queries. So why don’t follow me step by step on how to perform EDA easily with the great help of Datagrip and SQL. It’s like saying ‘hi’ to your fellow lovely dataset so that we could gain confidence in every extracted information we get from the data later on. This is the first and foremost step to do at the beginning of any project, before we jump into more sophisticated work like refactoring or modeling. Exploratory Data Analysis (EDA) is something that we do pretty frequently.
0 Comments
Leave a Reply. |