Getting the list of database objects for a parent role
AzharuddinK 09-Apr-21 2 0
I have a parent role that is connected to multiple child roles using the hierarchy. Is there a way
-
-
Converting Permanent table to Transient Table in Snowflake
npack 26-Jan-21 4 1
Snowflake Transient tables are similar to that of permanent tables except they dont have fail-safe -
Monitoring Query Costs in BigQuery by user using SQL and the Query Logs
npack 23-Nov-20 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 04-Nov-20 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 04-Nov-20 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 24-Sep-20 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 16-Sep-20 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 16-Sep-20 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 16-Sep-20 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 05-Sep-20 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 05-Sep-20 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 05-Sep-20 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 05-Sep-20 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 01-Sep-20 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 24-Aug-20 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 14-Aug-20 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 12-Aug-20 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 12-Aug-20 0 0
How to find how many times "Jazz" appears in "JazzbuzzJazz" string in Bigquery using SQL. The outpu
