-
Checking a columns datatype
Does anyone know if there is a way to check a column's datatype? I've noticed sometimes if bad data gets uploaded to a datasource it can change the columns type (for example from an int to a string) and I wanted to write a query to catch that faster. Anyone have any ideas?
-
Run of DataFlow Times Out
I've got a dataflow that times out whenever I try to run it. The eror message says "Cache file timed out", and it looks to happen somewhere around 10-12M rows. I'm filtering one of the tables to reduce the number of records to process, but the time-out error occurs before it gets to the filter step. Any suggestions?
-
Best practice for dataset refreshing in DataFlow
Hi, I am wondering if there is a better way than mine with regard to dataset refreshing. Please advise. I am dealing with an aggregated daily order dataset on DOMO which has more than million records in total. Let's call it "order_dataset". The original data source is an external database, so I push data from it via…
-
Join Types Redshift
What are the syntaxes for joins in redshift? Full Outer left right Don't seem to work only the word "join"
-
is there a way to push data to a third-party?
I would like to know if there is a way to push data from DOMO to a third-party tool, like Exact Target. Thanks, Wade
-
How do I share a dataflow?
I'm an admin, I have someone who is privilged. How do I share the dataflows I have created without making him an admin?
-
Comparing Data Sets
If I have a data set on an inventory of items and a second data set on the sale of those items, how might I compare those data sets with Domo to discover 1) which items in our inventory have never been sold and 2) the average length of time before items added to our inventory are sold? Thanks!
-
Domo on handling tranactional data and dimensional changes type 1 and type 2?
* By using Domo’s built-in data capturing methods.* How does Domo handle transactional data?* How does it handle duplicate data in regards to transactional data? * How does Domo handle dimensional changes (Type1 &Type2)?* Type 1 - old data is overwritten by new data * Type 2 – multiple records are created to track data…
-
Magic ETL/MySQL ETL and Datasets
Is there a way to see what ETL created a dataset? If the ETL tool showes and error at 46,796,637 rows, how are there 85,722,082 rows in the dataset?
-
Has anyone tried to create a custom schedule for an ETL job?
I am trying to create a daily snapshot of our datasets regardless of whether the data change or not. The current ETL process I have created can do such, so long as the dataset in which I am pulling data is update. However if the data is never updated, the ETL is never kicked off, which can create a gap in our day to day…
-
Monitor Dataflow in Card
Is it possible to monitor number of dataflow, failed data flow, sucessfully ran dataflow per day in a card? In short, is there any monitoring tool available for dataflow?
-
SFDC data connector- report
Hi all, I have a quick question on SFDC data connector. I’m trying to pull SFDC Task object data in Domo which includes our TLG call and dial data. However, the task object seems to be too big to be imported. I only selected 5 fields in the object and it took forever to import. I saw another option to import SFDC is…
-
Dynamically importing files.
I have a situation where a data source is coming in via email only, no available data connector in Domo. The file needs to be appended with a snapshot per email. Is there an automated file archive processes that Domo can provided? Basically, i would need to create a connection to pull the data from a file in a folder path,…
-
Is there a way to join data on a date between a start and end date?
This is really a data flow question. I have assignments in one table that have a start and end date. I am trying to join this to daily activity. set one look like code start_date end_date sm 1/1/2015 2/1/2015 asc 2/2/2015 6/2/2015 then there is daily activity and I need to see how much daily activity happened under each…
-
How to Capture Transactional Data Changes in Domo
We are loading sales order and purchase order data via Workbench from our ERP to report on booked orders, open orders, etc. However, our sales orders may be opened for a long period of time and frequently change. For example, the customer may revise their quantities ordered throughout the month prior to shipment. The only…
-
Normalize data in Domo.
I have a data source that looks like this: Type BusinessUnit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sale US 4 6 7 2 1 3 4 6 8 2 1 7 I want it to look like this: Type BusinessUnit Month Amount Sale US Jan 4 Sale US Feb 6 Sale US Mar 7 etc etc an I do this once the Data source is in Domo maybe via Data flows if no…
-
Has anyone noticed that the Domo Zendesk Connector not sending over Closed by Merged tickets?
I'm currently in the process of creating reports originally made in Zendesk Gooddata. In our attempts to recreate the report in Domo we have noticed that the tickets tagged "Closed_By_Merge" are not coming over in the data set when using a general query Has anyone else seen this?
-
Existing Data Flows are unavailable to update
2 of my DataFlows are no longer available for Editing. i can edit the name/description, but i can not update the actual DataFlow. this is because the don't appear in the DataFlow section of Data Center. anyone else come across this?
-
I added new View(Profiles) to Google Analytics but they are not in Domo
To make the new Google Analytics View(Profiles) available for the Domo user, you need to grant permission for those View(Profiles) in Google Analytics. Step 1. Sign into Google Analytics and navigate to the main page that shows the View(Profiles. Step 2. Go to the dropdown next to your email address at the top right and…
-
Hierarchical Relationship Between Columns In Data Sources
Some of the sources I work with have columns with a hiearchical relationship. For example, in the following data source, there are two columns named Master Source and Lead Source: The Lead Source (Column C) is always a subset of the Master Source (Column B) . Is there any sort of code that would set up the relationship…
-
Best Practices On Changing Data Sources
Our company has been using Domo for a few months, and when we began, I constructed a large variety of cards from the .csv files that we used for uploads through Workbench. Now our dataflows are shifting over to the databases themselves. Are there any best practices for transferring the cards from data sources dependent on…
-
Search Term and other dimensions in Google Analytics
Hello everybody, I've been working with Google Analytics and Domo for more than a year. I know that Google Analytics connector is still in Beta and I was hoping that it this new conector allow us to select the dimensions and metrics we are looking for. This conector has predefined dimensions and metrics (that can be useful…
-
Would you like a tool that unlocked more power than Beast Mode?
Have you ever wanted to do more in Domo as a technical person and wanted a tool that unlocked more power than Beast Mode? See our tool called “magic”. Click Here to Learn More
-
Difference Between 2 Google Analytics connectors
My cusotmers try to use GA connector. Now 2 Google Analytics connectors are available on Domo. I can not identify differences between 2 connectors. I would appreciate if give a guidance which one I should use. Regards, Shin
-
How can I get access to the DataFlow functionality
Please contact Domo Support (support@domo.com) to get enrolled in our DataFlow certification course. It is a self-taught course that ensures individuals have a basic understanding of MySQL. Thanks
-
How do I apply regex filters in the Google Analytics connector?
-
How to add multiple commands in one Transform inside a dataflow?
How do I make so I can insert multiple commands in one Transform box. For example, I am adding multiple indexes and don't want to have to create them in multiple transforms. create index SO1 on tech_salesorders(Sales_Order_ID) create index SO2 on tech_salesorders(Customer_Organization_ID) create index SOL1 on…
-
What does the "Use Raw Numbers" setting for email connectors do?
Recently, we ran into an issue with one of our email connector datasets where a "Currency" column was being formatted as a string which was causing issues down the line in other dataflows. We're not sure how the problem initially started, but we found that enabling the "Use Raw Numbers" setting seemed to fix it and…
-
Google Analytics Connector - Page Views with no Sessions - how come?
Hi, we've been using the GA connector for a while now with no issues but have noticed on a specific day that there are page views with no related sessions. How is this possible? Is there potentially something we have setup incorrectly in the Domo to GA connector.
-
Adobe Analytics and Domo Connection
Hi everyone, DOMO Database: we created a Dataset and were able to pull up a basic report. However, while trying to add some of the required dimensions and metrics into the dataset, we are receiving the following error, the screenshot of which is also attached. We have Admin Access to both Adobe Analytics and DOMO. “Domo is…