Datameer Blog

Tag: FAQ

snowflake-qa-datameer

Loading Data into Snowflake with Efficiency

Let’s pretend you are in charge of running a weekly survey about the impact of COVID on people’s day-to-day lives and analyzing the results of the data. All the information...

  • How-Tos FAQs
  • November 23, 2021
snowflake-qa-datameer

Add identity or autoincrement to table in Snowflake

In this tutorial, we will look at two different ways to add an autoincrement or identity column to an existing table in Snowflake. We will also discuss the limitations and ...

  • How-Tos FAQs
  • November 22, 2021
snowflake-qa-datameer

How to use subqueries and table expressions in Snowflake

In this tutorial, you will learn how to use subqueries and common table expressions in Snowflake. We will also discuss where and when to use each. Lastly, we will touch on ...

  • How-Tos FAQs
  • November 22, 2021
snowflake-qa-datameer

How can I view row counts of all tables in a Snowflake database?

In this article, you will learn how to view row counts of all tables in a Snowflake database. Data like row counts are typically stored in a metadata table in most database...

  • How-Tos FAQs
  • October 2, 2021
snowflake-qa-datameer

Merge parameters or variables of stored procedure into another table in Snowflake

Stored procedures are used to run a script that can contain several SQL queries, which are run in sequential order. Let’s look at how to merge parameters or variables...

  • How-Tos FAQs
  • June 9, 2021
snowflake-qa-datameer

What are the options when it comes to handling data lineage in Snowflake?

While Snowflake is a great high-performance data warehouse, its main focus is providing data warehouse infrastructure-as-a-service. Snowflake has partners specializing in E...

  • How-Tos FAQs
  • June 7, 2021
snowflake-qa-datameer

Connecting Snowflake to Tableau Online

Connecting Snowflake to Tableau Online is a fairly easy task. There might be an initial one-time set up to ensure Tableau Online can communicate with Snowflake. Once the in...

  • How-Tos FAQs
  • April 12, 2021
snowflake-qa-datameer

Materialized View vs Table with Dbt in Snowflake

Materialized View vs Table with Dbt in Snowflake Deciding to create a view or a table in Dbt is a common design decision when transforming data for use in analytics and BI ...

  • How-Tos FAQs
  • March 29, 2021
snowflake-qa-datameer

Format Numbers With Comma Separation in Snowflake Result Set

In order to customize format numbers with comma separation in Snowflake result set, fields with a number data type first need to be converted to a string, by casting to var...

  • How-Tos FAQs
  • March 29, 2021
snowflake-qa-datameer

How to connect to Snowflake using SSO authentication from DBT

Let’s explore how to connect to Snowflake using SSO authentication from Dbt. This article refers to connecting to Snowflake through the Dbt command line, not DBT Clou...

  • How-Tos FAQs
  • March 29, 2021
snowflake-qa-datameer

How to parse a variable in Snowflake as a source reference in dbt

There are a number of reasons why you might want to have a dynamic source in dbt. Variables are one way to achieve this. But, there are issues with using dynamic sources in...

  • How-Tos FAQs
  • March 29, 2021
alteryx FAQ

How to create a Pivot Table in Alteryx

Pivot tables are a very useful tool in Microsoft Excel used to group and summarize data of a more extensive table within one or more discrete categories. This summary might...

  • How-Tos FAQs
  • March 23, 2021
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]
[class^="wpforms-"]