Best Of

Re: Total Rows In Datawarehouse

You can get exact row counts using the Domostats datasets report. Dataset views are considered “virtual rows” that are considered stored rows from a credit consumption perspective.

ColemenWilson

1

Re: Duplicate value handling in ETL

It doesn't appear that you have a lot of consistency to go off of since some of your first words have spaces and sometimes your first word is also the second word. Are the words at the end consistently the same? If so, you could look at the end of the string using the RIGHT() function and if it equals Referral or Internet, then you could use the REPLACE function to replace that word with nothing.

MarkSnodgrass

1

Intro

Hello Domo Community,

I am going on 13 years of using Domo, since the super secret NDA days and I have been loving it since!!! As always I am here to share knowledge and help out where I can, but also to see the cool things you all are doing!

Harganz01

4

Re: Bullet Chart Data Labels

@calvert_schaefer @NDoyle Domo informed me this morning that the problem is resolved.

AaronCrouch

2

Re: Incremental refreshes using Domo Workbench

https://community-forums.domo.com/main/discussion/comment/83254#Comment_83254

No, it will only pull in the data that was updated based on the update timestamp from your database thus reducing the amount of data pulled in and processed. If you're wanting to remove old data then you can look into partitioning as @MarkSnodgrass mentioned.

GrantSmith

1

Re: Allow naming of tables in Snowflake with Cloud Amplifier

Hi all - this issue has been resolved, and when using Domo to create new tables in Snowflake those Snowflake tables will now reflect the name of the DataSet from Domo.