Monitoring Query Costs in BigQuery by user using SQL and the Query Logs
npack 7d 0 0
BigQuery is a SAAS Software, you get charged based on the amount of data scanned by your SQL Querie
-
-
what is the best way to export data from snowflake to postgres?
Alejandro-Merchan 25d 1 0
Currently, I'm working in an ETL that needs to migrate some tables from Snowflake to Postgres, anyb -
How to perform transpose of resultset in Snowflake
vikramk271 26d 1 0
Below attached ss are the sample data of my join query, now I want to achieve transpose of this dat -
Do we implement a star schema datamodel in snowflake cloud (is there a concept of star schema w/ dimesnions and facts)
rnarla 67d 1 0
Is there a concept of dimension and fact table data modeling aka star schema modeling in snowflake -
BigQuery error: Table name "XYZ" missing dataset while no default dataset is set in the request. at [x:y]
npack 75d 0 0
When creating a table in Bigquery make sure the table name is prefixed with the dataset (i.e. Datab -
Bigquery error: CLUSTER BY expression must be groupable, but type is STRUCT at [x:y]
npack 75d 0 0
When creating a table in Bigquery you might stumble on this error. Look at the below example query: -
How to build a calendar DIM_DATE table in Bigquery without using any source table?
npack 75d 8 0
The calendar table is used extensively in reporting to generate weekly / monthly /quarterly reports -
Google Bigquery: How to convert a column to a row
npack 86d 0 0
Often we want to store the aggregated values in different rows (move columns to rows), in order to -
Using bq command line - examples to run SQL, check job status, get destination table using Gcloud Bigquery SDK
npack 86d 0 0
Gcloud SDK comes with bq utility, its a command line tool (CLI) which can be used to interact with -
Column name is ambiguous error in Google Bigquery
npack 86d 0 0
When you are joining multiple tables in a SQL query and if a column with the same name is present i -
Hashing functions in Google Bigquery (MD5, SHA1..) - Generate Unique Id concatenating multiple fields
npack 86d 0 0
A hash function can be used to map data of arbitrary size to fixed-size values. The values returned -
Is there any way I can convert data from one language to another in snowflake?Yogesh-Agrawal 90d 1 0
I have a requirement to convert chinese data into English. Is it possible in snowflake? If anyone h -
How to schedule loading of excel file into snowflake?
jgrover 98d 2 0
One of my client is having daily excel data (approx 1 million records). This file need to be loaded -
How to migrate data from Oracle to Snowflake
ramesh-hdpsqlsnowflake-gmail-com 108d 1 0
How to migrate data from Oracle to Snowflake without using any tool or extracting data into CSV Fil -
How to Upload a CSV file to Bigquery Table using the Web User Interface
npack 110d 0 0
You can directly load a CSV file from your Laptop / Desktop / GCS Bucket directly into a Bigquery t -
How to find the number of occurences of a string in a string column in Bigquery
npack 110d 0 0
How to find how many times "Jazz" appears in "JazzbuzzJazz" string in Bigquery using SQL. The outpu -
Bigquery error - Subquery of type IN must have only one output column
npack Jul 24 09:14 0 0
Bigquery allows only one column as part of the subqueries. If you have more than one column, for ex -
Google Cloud Professional Data Engineer Certification Exam - Study guide and Practice tests
npack Jul 24 08:59 0 0
I cleared the Professional Data Engineer Certification recently and the question topics are fresh i -
Aws RDS to snowflake incremental load
Zohaib Jul 19 03:46 1 0
What can I use for incremental load from AWS RDS to snowflake and then load the changed data into f
