-
Snowflake use cases
Hi everyone, currently we use Domo and have some data sources we collect from multiple businesses. Without going into much detail, does anyone here use SnowFlake and have it integrated into Domo? If so, or even if not, what are the benefits of using Snowflake along with Domo?
-
API Partitioning
Hi all, so I want to use the Domo API's to do partitioning. That is, I want to send data daily, and I do not want the data there to be overwritten. I am trying this but I think it is being overwritten: https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=PARTITION Is this the correct way to upload via partition?…
-
API using partition
I have a question. I am using APIs now and I would like to know if it is possible to do partitioning using APIs. I know using Magic ETL and using Workbench you can do it, but can you do it using APIs? If I can't is the next step doing recursion? The reason for asking is that I am uploading data daily and would like to add…
-
using Domo API and partition
Currently i want to append data using the API append method. However, i also want to update the last 2 days 2 a dataset on a cron job so that i do not miss a day. I know partitioning would only keep the unique record. Is it best to use recursion or partitioning for this?
-
uploading data to a dataset - Domo Developer API
I am pretty new to Domo Developer. I would like to use a python script to daily upload data to a dataset. Here is my script. def append_data_to_dataset(dataset_id, dataframe, access_token): """ Append a pandas DataFrame to a Domo dataset. headers = { 'Authorization': f'Bearer {access_token}', 'Content-Type': 'text/csv' }…
-
pivoting data
Hi, I have data in this format: Date Island Count 2021-01-02 Aruba 4 2021-02-01 Curacao 9 2021-03-01 Curacao 10 I would like the data to be formatted this way: Island 2021-01-02 2021-02-01 Aruba 4 7 Curacao 9 10 This format is for a table view
-
resursion
i have a large dataset that is too large on the SQL source to bring in monthly so I have to bring in daily. So, I need to find a way to keep a few months of data in Domo. What would be the best way to do this? Should I use recursion? Is partitioning another option? I'm not too sure how these work. Would someone be able to…
-
Time change
Hello, currently I am pulling data via an ODBC Connector and pulling through Workbench. What I am finding is, when I query the data locally on the server I am seeing the correct dates, however, when I am pulling it through Domo the datetime is 4 hours behind. How do I correct this? Currently I am in EST time.
-
window function
I have the following table and i would like to understand how to get the difference between dates: id | status | date 1 | disconnect | april 4 1 | reconnect | april 7 2 | disconnect | june 4 I would like to understand the average days that persons reconnect in the entire dataset. Can a partition function work here? The…
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I…
-
Saving States
Is there a way to save data and possibly append to it? Let me give an example. When I pull data from a database, I would like to pull data and when I pull data tomorrow I want the original data to still be there. So I want to be able to see user counts by region today, and then in a month I would still like to see what it…
-
Joinin on Email
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
-
Formulae function for table instead of line by line
I have two tables. The first table i have a list of telephone numbers. The second table, a list of the first 3 digits of the number. I want to qualify the first with the next. Here is my formulae: case when SUBSTR(Phone,4,3) not in(NXX) then 'no' else 'yes' END so this is fine in that it qualifies line by line. However, I…
-
unpivoting data
I have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | Phone | 01/02/22 12 | TV | 01/01/22 I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way: Account | Category | Date 12 | Phone, TV | 01/01/22 13 | Phone | 01/02/22…
-
Beast mode for dates
I have a dataset that looks like this: Date. Customers Jan 01. 20 Jan 02 22 Jan 03 26 Jan 04. 29 What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode…
-
Large dataset import in Domo Workbench
Hi everyone, I have a very large dataset (18M rows) that I want to import and it takes too long. The query is already a grouped query so there is no unique ID. I am just trying to figure out if there is a way to import possibly a one time chunk (the data is for 2 years) and then maybe append the data after that. So maybe…
-
Unable to Schedule Jobs
Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error: 'Could not fix consecutive blocks of CRON schedule' Does anyone know how to resolve?
-
Accessing Dataset
Hello everyone, I am using Domo Workbench, and currently I am trying to run a dataset while using an ODBC connection. When I execute the job, it runs fine, however, when I go to Domo datasets I do not see it there. When I execute from Workbench it is executing as another user (another owner). Is there a way I can still see…
-
Flow for dates
I have the following table: Id Service Start Stop 12 Mobile Jan May 13 TV Feb Sep what I want to do is reshape for a line chart to have counts of accounts for active services: id date service 12 feb mobile 12 march mobile 12 Apr mobile 12 May mobile 13 Feb tv etc…
-
Create beast mode dates
Hi everyone, help needed! Here is how my table looks below. What I want to show in Analyzer is the count of accounts of these services over time. My problem is how the dates are shown here. Any advice on what I can do? I thought about creating a calculated field to index dates but not sure how to do it. Any help is…
-
Aggregating Numbers
Hello, I have a table that has both positive and negative numbers in them (in my ETL process). What I would like to do is leave it this way, and in the visualization, allow when using a chart for the calculation to take place. Is this possible? For example: Name | Amount Joe | 10 Mary | -20 This is how the tabular data…
-
SQL Flow taking hours to run
I am trying to run the following flow using the following SQL code: select adv.`Account`, adv.`LDGRDATE` Adv_Ledgerdate, cre.`LDGRDATE` Prorate_LedgerDate, adv.`Total_Amnt`, cre.`Total_Amnt` Prorate_Amount, adv.`Ledger Type`, cre.`Ledger Type` Prorate from `test_grp` adv left outer join `credit_prorate` cre ON…