Tuesday, May 14, 2019

DataEng: GCS: BigQuery



BigQuery can be performed in the Console's BigQuery or through Jupyter Notebook. Prior to performing a query from Jupyter Notebook, a user might want to make sure if the table even existed first as Jupyter Notebook will not provide any indication if the table doesn't exist [Learn].

The following example indicating that in my Dataset, I do not have any tables. Even though I can perform a query on Jupyter Notebook, it would not error out.


No comments:

Post a Comment

Pandas: SQL Like pandas operations

Pandas's SQL Like operations such as WHERE clause. = != >= str.contains() & | .isin() .isnull() .notnull() ....