Articles

• Converting Permanent table to Transient Table in Snowflake
• Solved: Snowflake Unsupported subquery type cannot be evaluated
• Monitoring Query Costs in BigQuery by user using SQL and the Query Logs
• Adding to DATE using DATE_ADD Syntax in Google Bigquery
• BigQuery error: Table name "XYZ" missing dataset while no default dataset is set in the request. at [x:y]
• Bigquery error: CLUSTER BY expression must be groupable, but type is STRUCT at [x:y]
• How to build a calendar DIM_DATE table in Bigquery without using any source table?
• Google Bigquery: How to convert a column to a row
• Using bq command line - examples to run SQL, check job status, get destination table using Gcloud Bigquery SDK
• Column name is ambiguous error in Google Bigquery
• Hashing functions in Google Bigquery (MD5, SHA1..) - Generate Unique Id concatenating multiple fields
• How to Upload a CSV file to Bigquery Table using the Web User Interface
• How to find the number of occurences of a string in a string column in Bigquery
• Bigquery Error: No matching signature for function CONCAT for argument types. Supported signatures: CONCAT
• Bigquery error - Subquery of type IN must have only one output column
• Google Cloud Professional Data Engineer Certification Exam - Study guide and Practice tests
• How to count distinct values over multiple columns using SQL
• Awesome, free Data tools for SQL Developers and Data Engineers
• How to rename a column name in Google Bigquery table - with Examples
• Execute Dynamic SQL Queries with EXECUTE IMMEDIATE in Bigquery - with Examples
• How to find DISTINCT values in a ARRAY in Bigquery
• How to rename a table in Google Bigquery ?
• How to do Case Insensitive Sorting (order by) in Google Bigquery
• How to do Case Insensitive compare in Google Bigquery ?
• IDENTITY or AUTO_INCREMENT columns in Google BigQuery
• Bigquery Table too large to be exported to a single file. Specify a uri including a * to shard export
• How to trim and display only 4 digits / decimal places in Bigquery Numeric ?
• How to truncate after 4 digits / decimal places in Bigquery Numeric columns ?
• How to round up to 4 digits after decimal point in Bigquery ?
• REGEXP_MATCH function equivalent in Google BigQuery SQL
• Calculating Running Total with OVER Clause in SQL - Bigquery / Snowflake / Teradata
• DefaultCredentialsError: Setting GOOGLE_APPLICATION_CREDENTIALS for BigQuery Python CLI
• Find all Table columns, datatype and metadata information in Google BigQuery using Information Schema
• How to Add New Columns to a Table in Google BigQuery
• How to download a table data from Google BigQuery ?
• WITH Clause - Common table expressions in Bigquery
• Formatting date in Google Bigquery results to mm/dd/yyyy or dd-mm-yyyy and other formats
• Using Variables in Google Bigquery
• How to Truncate a table in Google Bigquery
• Export a BigQuery table's schema definition into JSON ?
• What is the difference between BigQuery vs BigTable ?
• How to Recover deleted rows with Time Travel in Snowflake
• Snowflake Data Warehouse Free Tutorial
• How to find the Storage size of a SINGLE COLUMN in a Table in Snowflake ?
• How to Compare two Tables in SQL efficiently - quick and easy method
• How to find FIRST_DAY, LAST_DAY of current month, next month, previous month in Google Bigquery
• Create Primary Key command syntax in Snowflake
• Create Foreign Key command syntax in Snowflake
• How to find list of Schemas in Snowflake
• How to find the List of databases in Snowflake
• Bigquery Simba ODBC Driver: Error interacting with REST API The user does not have bigquery.datasets.create permission in project
• BigQuery ROW_NUMBER Order by Error: Resources exceeded during query execution: The query could not be executed in allotted memory
• CREATE MATERIALIZED VIEW Syntax in Snowflake
• While setting up Initial Snowflake Environment, single vs multiple Accounts- Architecture Best practices
• Identity or Auto Increment columns in Snowflake. How to handle them while migrating
• How to get Rowcount or Activitycount inside Snowflake Stored procedure
• Loading large volume of data into Snowflake using ODBC / JDBC
• How to set up a destination table for a scheduled query in Google Bigquery
• Numeric value 'xyz' is not recognized. How to fix the Snowflake Error message
• Undrop a table in Snowflake / How to use time-travel on a dropped table in Snowflake
• Rows between unbounded preceding and unbounded following in Snowflake - Window Function Syntax
• How to find Bigquery storage size for a single table / all tables in a dataset - Google Bigquery
• How can I undelete from a BigQuery table? Recovering data from deleted table from Web UI
• Stored procedures in Snowflake
• Snowflake now handles 300 million queries per day from its customer base
• Window functions - Rows between current row - Snowflake syntax
• ROW_NUMBER() syntax in Snowflake
• Rank() syntax in Snowflake
• Cast as Integer syntax in Snowflake
• Extract command syntax in Snowflake
• DATEDIFF command syntax in Snowflake
• TO DATE syntax in Snowflake
• Snowflake Left outer join syntax
• Snowflake Inner Join syntax
• Merge command syntax in Snowflake
• Update command syntax in Snowflake
• Insert into table command syntax in Snowflake
• ORDER BY Syntax in Snowflake
• GROUP BY HAVING Syntax in Snowflake
• GROUP BY Syntax in Snowflake
• Time travel query syntax in Snowflake
• WITH Clause - CTEs (Common Table Expressions) in Snowflake
• DROP TABLE syntax in Snowflake
• Cast String dd/mm/yyyy as Date / PARSE_DATE syntax in Google Bigquery
• Delete command syntax in Google Bigquery
• MERGE command syntax in Google Bigquery
• Update table command syntax in Google Bigquery
• Insert table command syntax in Google Bigquery
• Create view syntax in Google Bigquery
• DATE_DIFF Syntax in Google Bigquery
• Subtracting days using DATE_SUB Syntax in Google Bigquery
• DATE_ADD Syntax in Google Bigquery
• EXTRACT Day / Month / Year from Date or Timestamp Column in Google Bigquery
• How to get todays date / CURRENT_DATE in Google Bigquery
• CAST AS NUMERIC syntax in Google Bigquery
• CAST AS INT64 syntax in Google Bigquery
• UNION ALL vs UNION DISTINCT SET Operators in Google Bigquery
• ORDER BY clause syntax in Google Bigquery
• HAVING clause syntax in Google Bigquery
• GROUP BY clause syntax in Google Bigquery
• Table Joins in Google Bigquery - Syntax
• Subqueries in Bigquery - syntax
• UNNEST syntax in Bigquery
• Querying Bigquery table FOR SYSTEM_TIME AS OF - Time travel
• Rank vs Dense_Rank in Bigquery - Syntax
• Rows between unbounded preceding and unbounded following in BigQuery - Window Function Syntax
• ROW_NUMBER() OVER PARTITON BY Syntax in Bigquery
• RANK() OVER PARTITON BY Syntax in Bigquery
• Table or Column Alias in Bigquery - Syntax
• SELECT * EXCEPT a specific COLUMN in Bigquery - Syntax
• SELECT DISTINCT Values from a Bigquery - Syntax
• SELECT * from a table in Bigquery - Syntax
• Temporary CTE Table in Bigquery using WITH Clause
• CREATE TABLE AS SELECT from another table in Bigquery (Copy DDL and Data)
• Snowflake Course Intro
• What happens when you execute a query in Snowflake and Logoff ?
• BigQuery Syntax Equivalent of Decimal()
• How to get array length / size of a nested field in big query
• Google BigQuery Supported Column Data types
• Creating a new dataset in BigQuery
• CREATE TABLE Statement syntax in BigQuery
• How to implement an Insert which has a subquery in Snowflake?
• TRANSLATE syntax and usage in Snowflake Datawarehouse
• How to remove newline / special character from a column in Snowflake Datawarehouse
• Find and Replace in Snowflake Datawarehouse
• Pitfalls of using Snowflake Time Travel as your database backup strategy
• How to increase concurrency of query execution in Snowflake
• Unloading data from Snowflake tables
• DATEADD(): Add or subtract from a date column in Snowflake
• Load Data into Snowflake using SnowSQL
• Install and Configure SnowSQL CLI Client
• Snowflake Data Warehouse Overview (Video)
• Basics of cloud data warehousing and saas
• Setup the environment in Snowflake
• Snowflake Training / Course
• Learn Snowflake from Scratch - The Ultimate Course
• Real experience stories from Snowflake end users
• Does Bigquery support triggers?
• MERGE Command syntax in Snowflake
• CREATE TABLE LIKE Statement in Snowflake (Copies only DDL)
• Snowflake Datawarehouse vs Teradata
• What is Snowflake DataWarehouse and how does it work - The Architecture
• Welcome to the community ! start here
• BigQuery - Handling Division by Zero Error
• BigQuery Union Error: Syntax error: Expected keyword ALL or keyword DISTINCT but got keyword SELECT at []
• How to remove duplicate rows in BigQuery based on a unique identifier
• Cognitive biases that you should be cautious of
• R vs Python for Data Science. The epic battle
• Machine learning project in python to predict loan approval (Part 6 of 6)
• Your second Machine Learning Project with this famous IRIS dataset in python (Part 5 of 6)
• Your first Machine Learning project in Python with Step-By-Step instructions (Part 4 of 6)
• How to setup python environment for Machine Learning with Anaconda (Part 3 of 6)
• Types of Machine learning algorithms (Part 2 of 6)
• The ultimate machine learning course with python in 6 steps ! (Part 1 of 6)
• Teradata String Manipulation - Remove last character
• How to remove milliseconds from timestamp(6) / datetime in Teradata
• TERADATA - Finding the position of a substring in a string
• How to cast a bigint into decimal in Teradata
• How to fetch a sample of data within each group - Teradata
• How to run a BigQuery SQL in Python
• How to Insert multiple Rows in Teradata using SQL
• Google BigQuery: How to convert a Date / Timestamp to a different timezone
• How to do inner join on two tables in Teradata
• How to find out the tables with specific column names in them in Teradata?
• DECIMAL datatype behavior while doing calculations in Teradata
• Teradata: The UserId, Password or Account is invalid
• How to automate exports in tab-delimited form from Teradata fast export ?
• What is the difference between Qualify and Having - Teradata
• How to find out when the table was last modified in Teradata?
• How to use Teradata OTRANSLATE() function - syntax ?
• How to find if a column has alphabets in Teradata
• Teradata : Transpose columns to rows
• Teradata locks - How to find if a table is locked?
• Teradata error - Selected non-aggregate values must be part of the associated group
• How to filter with multiple columns with multiple values in where clause in Teradata
• Identity column in Teradata
• How to check all access rights for a Teradata user ?
• Teradata: How to compare potentially null fields without using coalesce?
• Compare date column with varchar in Teradata
• Modifying Primary Index of a table in Teradata
• Teradata : Alter table to change primary index to unique primary index
• Create volatile table in Teradata
• CREATE TABLE statement in Teradata
• CREATE GLOBAL TEMPORARY TABLE in Teradata
• Dropping SECONDARY INDEX in a Teradata table
• Drop statistics on a column in Teradata
• Drop a foreign key constraint from a Teradata table
• Drop a column from a table in Teradata
• Rename a table in Teradata
• Rename a column in Teradata
• Change column datatype or length in Teradata
• Create Macro in Teradata
• Adding FOREIGN KEY to a table in Teradata using ALTER table
• Teradata Grant access statements
• Give - Transfer ownership of a database in Teradata
• Select query without a table name in Teradata
• Subqueries in Teradata
• Recursive Queries in Teradata
• Adding column to a table in Teradata