Code
Hub
Workspaces
Following
Trending
Connect
MCP
copy
Create free account
hub
/
github.com/SohierDane/BigQuery_Helper
/ functions
Functions
22 in github.com/SohierDane/BigQuery_Helper
⨍
Functions
22
◇
Types & classes
2
↓ 4 callers
Method
query_to_pandas
Execute a SQL query & return a pandas dataframe
bq_helper.py:129
↓ 2 callers
Method
__fetch_dataset
Lazy loading of dataset. For example, if the user only calls `self.query_to_pandas` then the dataset never has to be fetched.
bq_helper.py:33
↓ 2 callers
Method
__fetch_table
Lazy loading of table
bq_helper.py:42
↓ 2 callers
Method
estimate_query_size
Estimate gigabytes scanned by query. Does not consider if there is a cached query table. See https://cloud.google.com/bigquer
bq_helper.py:118
↓ 2 callers
Method
query_to_pandas_safe
Execute a query, but only if the query would scan less than `max_gb_scanned` of data.
bq_helper.py:148
↓ 2 callers
Method
table_schema
Get the schema for a specific table from a dataset. Unrolls nested field names into the format that can be copied directly in
bq_helper.py:92
↓ 1 callers
Method
__handle_record_field
Unpack a single row, including any nested fields.
bq_helper.py:52
↓ 1 callers
Method
__unpack_all_schema_fields
Unrolls nested schemas. Returns dataframe with one row per field, and the field names in the format accepted by the API. Resu
bq_helper.py:72
↓ 1 callers
Method
head
Get the first n rows of a table as a DataFrame. Does not perform a full table scan; should use a trivial amount of data as long as n
bq_helper.py:158
↓ 1 callers
Method
list_tables
List the names of the tables in a dataset
bq_helper.py:111
Method
__init__
(self, active_project, dataset_name, max_wait_seconds=180)
bq_helper.py:21
Method
setUp
(self)
test_helper.py:29
Method
test_bad_query_raises_right_error
(self)
test_helper.py:65
Method
test_estimate_query_size
(self)
test_helper.py:43
Method
test_head
(self)
test_helper.py:58
Method
test_list_nested_schema
(self)
test_helper.py:69
Method
test_list_schema
(self)
test_helper.py:40
Method
test_list_tables
(self)
test_helper.py:37
Method
test_query_safe_fails
(self)
test_helper.py:52
Method
test_query_safe_passes
(self)
test_helper.py:49
Method
test_query_to_pandas
(self)
test_helper.py:46
Method
test_useage_tracker
(self)
test_helper.py:61