evidence-dev / sqltools-bigquery-driver Goto Github PK

May need to handle these explicitly to unpack the objects

To reproduce

Open a sql file, run

select * from [table] limit 0

Expected result

An empty table

Actual result

Query with errors. Please, check the error below.
Cannot convert undefined or null to object

I have one service account connected to default project, but that service account also have permission to another projects too.
It seems like I can only add default project for the service account. please add a functionality to explore another projects on the side bar. thank you for the great project!

Add list of BQ keywords for autocompletion

Dry run allows you to see how much data will be processed during your query

Add

• Connection details (project name etc)
• icons for data types as columns?
• names of data types?

See snowflake for inspiration

Remove

• No need for top level database icon?
  • This maps to a "project" and only one can be connected to at a time in this implementation
• No need for "Tables" and "Views" folders - they can be distinguished by icons

For auto-completion of datasets (schemas), tables, columns etc

I'm looking to make a contribution to the project.

@archiewood have you looked into adding the query cost estimation to the plugin?

from google.cloud import bigquery

# Construct a BigQuery client object.
client = bigquery.Client()

# Set your query here
query = """
SELECT name, count
FROM `table`
WHERE state = 'TX'
"""

# Set up the dry run query configuration
job_config = bigquery.QueryJobConfig(dry_run=True, use_query_cache=False)

# API request - dry run query
dry_run_query_job = client.query(query, job_config=job_config)

# A dry run query does not provide a row iterator, only statistics
print(f"This query will process {dry_run_query_job.total_bytes_processed} bytes.")

Should be able to reduce size from ~10MB to a few KB

Hangs for 10 minutes without installing.

These bloat the package size unneccesarily

I didn't see this in the docs--is there a straightforward way to disable keyword autocomplete? Or only begin after a character for that keyword is typed?

Thanks!

It seems that only tables which have datalocation US show up in the explorer. None of my EU tables appear