I'm trying to structure a CTE/WITH-clause where I have one column that draws data from a table in our database, but then I need two columns with data that does not contain data from our database. This is where I need to be able to input unique data for each row. It also needs to be rather simple to update that data manually.
Any ideas on how to do this?
Hi @holmberg
Not exactly sure what you're trying to do, but if you just need a random data for the non-existing column, then perhaps just a UUID or hash?
It would probably be a little easier to understand if you provided your current SQL, since it doesn't really sound like it's specific to Metabase, but just a regular SQL help.
Hi @flamber!
So let me try and make it a little clearer. What I really wanted to do is create a temporary table, but I'm not sure if that is possible.
So to explain the data, the output I'm looking for is;
Column 1 - ID - this we already have in the database
Column 2 - Date - I have the date already, but not in our database
Column 3 - Event - I have the event already, but not in our database
Both the event and the date happens outside our database but in connection to the IDs and so I want to be able to insert that into the IDs rows.
I've been looking into creating temporary tables, INSERT INTO, also CTE + INSERT INTO but I'm unsure how to structure this in metabase