The Data Explorer section in the Workspace allows users to explore their data warehouse(s) and Data Observatory subscriptions as well as creating maps from their data.
From Connections tab, select a connection to view content (database/project(s), schemas/datasets, and tables) from top to bottom in a collapsible tree. If you haven’t registered a connection yet, you will see the following page.
If you want to create a connection you can use the Add new connection button that appears at the bottom of the tree in the Connection tab.
From Data Observatory tab, you can access the different Data Observatory datasets you subscribed to. If you haven’t subscribed to any dataset yet, you will see the following page.
In the same way, you can use the Add new subscriptions button from Data Observatory tab, in order to add a subscription from the Spatial Catalog.
This dataset is added as any other table in the Data Explorer. Meaning, that you can access the map and data preview of the table as well as creating a map in Builder.
When you select a connection to view the content (database/project(s), schemas/datasets, and tables/tilesets), you will be able to perform three actions through the buttons on the top right corner: Import, Refresh and Grid view.
The Import button will allow you to import your data into the available connections through two different methods: Local or Remote.
The Refresh button will allow you to update any change in the collapsible tree/view page.
You can also change the page view. By default the view is displayed as a table.
When you click on the Grid view button, your content will be displayed as cards.
In order to search for an specific content (database/project, schema/dataset or table/tileset), you can use the search bar to type what you are looking for.
You can also check the number of results that you are currently viewing on the list.
Click on the up/down arrow if you want to sort alphabetically in ascending or descending order.
From the list, you can also check whether it is a table or a tileset from the Type column.
Once your table or tileset is selected, you can check the full path of the table/tileset and click on the Copy qualified name link to copy it. You can also move through the path by clicking on the different folders (database/project and schema/dataset) or go back to the previous page by clicking on the arrow on the top left corner.
Partitioned BigQuery tables will fail to preview, since they always require a
WHEREclause in the query that filters by the column used for the partition.
They can still be loaded in Builder, adding them as a SQL Query source like:
WHERE partition_column = 'value'
Last modified 1mo ago