Avgidea Query Editor
From the Query Editor, you can issue queries against SPARQL instances scattered across the Internet or against predefined BigQuery datasources.
In addition, you can perform the following tasks only for BigQuery datasources
Save the query results
Retrieve schema information
Delete a table
Executing a query ( SPARQL )
Follow the steps below to specify a SPARQL endpoint and execute a query.
1. Login to the ADP console and select the "Query Editor" menu.
2. Enter the query details and click the "EXECUTE" button.
Product : SPARQL
Endpoint : A SPARQL endpoint that is accessible via the Internet
Query : SPARQL compliant query text
3. When the query is successfully executed, the results of the query execution will be displayed at the bottom of the screen.
Executing a query ( Google BigQuery )
You can perform a query against a single table in a configured BigQuery datasource by following the steps below.
1. Login to the ADP console and select the "Query Editor" menu. 2.
2. Enter the details of your query and click the EXECUTE button.
Product : BigQuery
DataSource : Pre-configured BigQuery datasource
SELECT : Columns to be extracted from the table
FROM : Table to be accessed via the datasource
WHERE : Search condition in SQL statement
3. When the query is successfully executed, the results of the query execution will be displayed at the bottom of the screen.
Saving Query Results
You can run queries on tables that are accessible via BigQuery datasources and save them as tables in the same or another BigQuery datasource.
1. Login to the ADP console and select the "Query Editor" menu. 2.
2. Enter the details of your query and click the SAVE button.
Product : BigQuery
DataSource : Pre-configured BigQuery datasource
SELECT : Columns to be extracted from the table
FROM : Table to be accessed via the datasource
WHERE : Search condition in SQL statement
3. After selecting the datasource to be saved, enter the table name and click the "SAVE" button to save it as a new table in the BigQuery dataset.
Getting Schema Information
You can view the schema information of tables that can be accessed via the BigQuery datasource.
1. Log in to the ADP console and select the "Query Editor" menu.
2. Enter the following parameters and click the DESCRIBE button from the drop-down menu.
Product : BigQuery
DataSource : Pre-configured BigQuery datasource
FROM : Tables that can be accessed via the datasource
3. At the bottom of the screen, the attributes and schema information of the target table will be displayed.
Deleting Data Tables
You can drop tables that can be accessed via the BigQuery datasource (for WRITE role only).
1. Log in to the ADP console and select the "Query Editor" menu.
2. Enter the following parameters and click the DELETE button from the drop-down menu.
Product : BigQuery
DataSource : Pre-configured BigQuery datasource
FROM : Tables that can be accessed via the datasource
3. A confirmation dialog will be displayed. Click the "OK" button to delete the corresponding table.