SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Discussion List
-
How could we implement a SQL Flow that would split lines based on certain logicHello, I have an ask where I need to split lines when there are multiple Users working at the same… -
MySQL WorkflowCan Domo's mysql handle more than 500k records? It shows the import can only go to 500k but I'm ass… -
Is there a roadmap for updating to MySQL v8?Hi, A client has asked if we will be updating to MySQL v8 soon as we currently only support MySQL …
-
3 month moving with current month for a date columnI am trying to calculate a SQL formula for a moving 90 day period based on month. For example what …
-
Dataset query fails when not using a where clauseI'm trying to get all the data from my dataset by executing a simple query: Here's what my code loo…
-
Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?My company is migrating from Mode Analytics to Domo, and I'm trying to understand whether and how I…
-
SQL DataFlow vs API accessHi DOJO Community, Good morning. Do any of you know why when I am querying the API the runtime betw…
-
Calculating hits per minute by timestamp and Parts ranI am trying to calculate a live hits per minute by machine based on total parts ran per the differe…
-
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL ConnectorHey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query …
-
Connect SQL Server Management Studio to DomoHi everyone, I have database in Microsoft Sql Server Management Studio. Is it possible to connect i…
-
Syntax for nullHi all, I am trying to create a formula in ETL that deals with the null values in multiple columns.… -
MySQLFor this question: Join together two DataSets with MySQL using the name, year, and gender columns a…
-
SQL Writeback - Importing to Existing SchemaIs there a way to specify a specific SQL schema the SQL Writeback connector uses? The documentati…
-
SQL View of DataSetsIs there a way to view the SQL query of an output dataset in Domo? We are working on exporting our …
-
MySQL Join Optimisation - 2 hours, for what should take seconds!!Hi, I have been trying to optimise a MySQL script, which for some reason is taking over 2 hours to …
-
Is there a better way to perform a variable-length recursive query using MySQL ver. 5.6?I'm looking to perform a recursive query on a data hierarchy with an unknown amount of levels. I've…
-
How can I use the MATCH() function with a declared variable string in a MySQL dataflow?I am looking for assistance in determining how to use the value of a string variable to DECLARE a p… -
Adrenaline version of SQLHi All, Can you please let me know what version of SQL does adrenaline use.. Thanks, Arun
-
Troubleshooting on Dynamic SQL in MySQLHello, I am having trouble on running below Dynamic SQL query. Can someone have a look and troubles…
-
Need help reviewing sql query used to create domo sql dataflowHello, I am working on moving one of our SQL Queries to Domo. This query looks for users who have …
-
Using a View as a input dataset to mysql dataflowHi All, I am trying to have (a view) as one of the inputs to the mysql dataflow...But its not being…
-
Creating a join from a lookup tableI have created a dataflow that joins two sets of data together, however when i join them together i…
-
LISTAGG or equivalent during data import from NetSuiteWhat SQL should I be using during an import to collapse data from a column into ',' delimited strin…
-
Calculate rank so that the smaller number is higher rankI need to calculate the rank on a metric where the lower value is higher in rank, and the higher va…
-
has anyone had any luck creating dynamic columns in mysqlwhat I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to …
-
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E…
-
Can I write SQL directly to my data sources?I know I can click on "SQL" in the top ribbon to write SQL against my data sources using …
-
MYSQL - Trouble adding new column via LEFT JOINHello! I am having trouble adding a new column, "Dummy", to my output dataset. Although t…
-
Schema not keeping changes, but no error given - have you run into this?Hello, So I have set up a job using MySQL ODBC - executed, all good. Job T Then set up another job …
-
'Incorrect column name' doing a Dynamic PivotHi there! I've been following this tutorial for dynamic pivot and so far it has worked: https://do…
Categories
- 7.7K All Categories
- 3 Connect
- 919 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 38 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 27 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部
