SQL
Discussion List
-
Can someone give me DDX Bricks examples which use traditional SQL (using JOIN) to query?I want to use traditional SQL to query to fetch data from database in ddx bricks. My sql query cont…
-
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 …
-
Generate Date Range Column from Two Date ColumnsHi all ! Im trying to generate a date column with a range of dates from two columns: Table I have …
-
Deduplicating a table based on the content of certain columnsI have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of…
-
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…
-
How to use Escape characters in Beast Modes?Hi, I am trying to create a web link for a card using a beast mode and some of the values that will…
-
Is AS valid in Beast mode?Good afternoon, Can AS be used in Beast Modes to create aliases? It doesn't seem like it but I migh…
-
Rolling Average for Each CategoryI have a dataset containing total monthly units by month and by person. I'd like to calculate the …
-
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…
-
Moving Values One Row Down - Conversion RatesHello! Does anyone know how to move the "Stage Count" column down one row (Stage Count 2)…
-
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 …
-
Rolling 30 Day Formula in magic ETLHi, I am trying to write the formula above within magic ETL. Column A consists of static values. C…
-
MySQL Protocol Version ErrorI'm trying to connect to a MySQL Account. When I enter in my credentials and CA Cert I get the erro…
-
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…
-
How to Create Monthly Averages for Headcount?Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Averag…
-
use fields from different tables group by date to calculate percentageHi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic T…Answered ✓ user095063 155 views 3 comments 0 points Most recent by jaeW_at_Onyx APIs & Domo Developer
-
Need help to connect a Microsoft SQL server to DOMOHow can I connect MS SQL server with Windows authentication mode only? Should I ask the server owne…
-
Problem with SQL for WordCloud ChartHi all! So, I am trying to run SQL code using these instructions https://domohelp.domo.com/hc/en-us…
-
Remotely trigger a DataSet refresh?I'm checking out some of our options for speeding up data ingestion in Domo. A few of our Postgres …
-
MySQL Recursion Performance/Speed IssuesHello! I am looking for suggestions on how to improve the performance of my mysql dataflow. Current…
-
Can you prevent the MySQL connector from locking its source table while syncing?I have a large table that takes a while to sync over to Domo through the MySQL connector. I current…
-
Appending an update set to itselfHi, I have a MySQL dataflow that is built from API reports from a vendors application. The idea is…
-
access max.date from sql tableHi. I have two input datasets in SQL Magic Transformation. One table called daily the other one est…