Click down arrow icon next to your project name and select "Create new dataset" menu.
Enter Dataset id and Click "OK" button
2. Select Google BigQuery Data Menu
Select 'Import Database Data' from Add Data Frames dropdown
Click 'Google BigQuery'
3. Authentication with Google OAuth
Select an account you want to use for your Google BigQuery and click 'Allow' button to allow Exploratory to extract your Google BigQuery data based on the parameters you are going to set up in the next step.
4. Write SQL Query
4.1 Preview Data
Type Data Frame Name
Select Google BigQuery Project from the dropdown menu
Enter query to SQL Query editor
Click Run button to preview data.
5. Standard SQL
You can now use Standard SQL by clicking the "Standard SQL Mode" checkbox on Google BigQuery Configuration Dialog.
Click the Edit button to open the Google BigQuery Configuration Dialog.
On the Google BigQuery Configuration Dialog, you can set the Standard SQL Mode.
BigQuery standard SQL is compliant with the SQL 2011 standard and has extensions that support querying nested and repeated data.
Standard SQL has several advantages over legacy SQL, including:
Composability using WITH clauses and SQL functions
Subqueries in the SELECT list and WHERE clause
ARRAY and STRUCT data types
COUNT(DISTINCT <expr>) is exact and scalable, providing the accuracy of EXACT_COUNT_DISTINCT without its limitations
Automatic predicate push-down through JOINs
Complex JOIN predicates, including arbitrary expressions
5.1 Composability using WITH clauses and SQL functions
Now you can use WITH clause which enables extraction or reuse of named subqueries. For example: