nVector - profile
My Community Posts
- 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 locks - How to find if a table is locked?
- Teradata : Transpose columns to rows
- 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