Can Snowflake Be Used a Data Source for Semarchy Dashboards?
F
Fathia Jama
started a topic
over 2 years ago
Can Snowflake Be Used a Data Source for Semarchy Dashboards?
Best Answer
F
Fathia Jama
said
over 2 years ago
Yes, Snowflake can be utilized as a Datasource for Dashboards by selecting the SQL-92 compliant database option when configuring your datasource. More information on Snowflake can be found here.
Yes, Snowflake can be utilized as a Datasource for Dashboards by selecting the SQL-92 compliant database option when configuring your datasource. More information on Snowflake can be found here.
G
Gleigh
said
over 2 years ago
We are also trying to see if that would also work in Redshift - the official Semarchy line that we got was that only 3 databases can be used as Data Sources, so Snowflake and Redshift are not supported fully if they are used to supplydata in a dashboard, discovery or try to reverse engineer. However, if there is sufficient interest in the community to improve connectivity options, they may make a commitment to add to the development roadmap.
F
Flavius_moldovan
said
over 1 year ago
Do you have any documentation for how to add Snowflake as a Datasource? (the link provided above does not work). Thanks!
F
Fathia Jama
said
over 1 year ago
Hi Flavius,
You would configure the snowflake data source in the same way as the other datasources.
In the drop down select Other as the database type.
Then populate the fields with the correct values.
F
Flavius_moldovan
said
over 1 year ago
Thank you!
F
Flavius_moldovan
said
over 1 year ago
It worked very well. Thank you very much! Will it be possible to use snowflake for everything and not use postgres at all?
F
Flavius_moldovan
said
over 1 year ago
Hello Fathia,
I tried to use the SnowFlake datasource to create a new location but I got an error. Do I do anything wrong or those are some known issues?
Hello Flavius, Snowflake support for xDM datalocation is not available yet. Snowflake is not meant for transactionnal queries by default, which made our performance tests look too bad to enable this support for the moment. We are collaborating with them to test their new Unistore feature that is supposed to perform much better for transactional use cases. However, we do not have access yet to this feature preview as work is still in progress on Snowflake side.
Fathia Jama
Can Snowflake Be Used a Data Source for Semarchy Dashboards?
Yes, Snowflake can be utilized as a Datasource for Dashboards by selecting the
SQL-92 compliant database
option when configuring your datasource. More information on Snowflake can be found here.- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstFathia Jama
Yes, Snowflake can be utilized as a Datasource for Dashboards by selecting the
SQL-92 compliant database
option when configuring your datasource. More information on Snowflake can be found here.Gleigh
We are also trying to see if that would also work in Redshift - the official Semarchy line that we got was that only 3 databases can be used as Data Sources, so Snowflake and Redshift are not supported fully if they are used to supplydata in a dashboard, discovery or try to reverse engineer. However, if there is sufficient interest in the community to improve connectivity options, they may make a commitment to add to the development roadmap.
Flavius_moldovan
Do you have any documentation for how to add Snowflake as a Datasource? (the link provided above does not work). Thanks!
Fathia Jama
Hi Flavius,
You would configure the snowflake data source in the same way as the other datasources.
In the drop down select Other as the database type.
Then populate the fields with the correct values.
Flavius_moldovan
Thank you!
Flavius_moldovan
It worked very well. Thank you very much!
Will it be possible to use snowflake for everything and not use postgres at all?
Flavius_moldovan
Hello Fathia,
I tried to use the SnowFlake datasource to create a new location but I got an error. Do I do anything wrong or those are some known issues?
This is what I used for datasource configuration:
Stéphanie FOURRIER
Hello Flavius, Snowflake support for xDM datalocation is not available yet. Snowflake is not meant for transactionnal queries by default, which made our performance tests look too bad to enable this support for the moment. We are collaborating with them to test their new Unistore feature that is supposed to perform much better for transactional use cases. However, we do not have access yet to this feature preview as work is still in progress on Snowflake side.
I hope this makes sense.
Best regards,
Stéphanie.
-
4 levels treemap in Dashboard Builder
-
If the data preview can see the data, why can't the chart preview get the data?
-
How to setup multiple roles for a Dashboard?
-
Is it possible to make a master-detail relation between two charts ?
-
Dashboards disappeared during migration of Semarchy database to RDS
-
The Data Location Variable (V_DATALOCATION) Doesn't Appear to Work in Dashboard
-
Set a default width for columns in pivot tables in the dashboards
-
Migrating a Dashboard to Production
-
xDM - Dashboard Advice
See all 14 topics