Enabling Workbench to read/recognize temp tables
Comments
-
Are you able to save the temp table into a format that could be easily uploaded via workbench? .CSV comes readily to mind here as a possible format for a workaround.
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
@Giancarlo, did the above reply by nalbright help address your question?
0 -
So this problem is caused because Workbench is asking the database server for the schema, but the database server (SQL Server in this case) is returning an error that it doesn't know the schema of the query due to the use of the temp table. The error will look something like:
ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]The metadata could not be determined because statement 'INSERT INTO #temp1 SELECT 2 As Col' uses a temp table.
One workaround that I am aware of is to use T-SQL to explicitly specify the schema. So instead of:
SELECT 1 As Col
INTO #temp1
INSERT INTO #temp1
SELECT 2 As Col
SELECT Col FROM #temp1
DROP TABLE #temp1You could execute something like:
EXEC ('
SELECT 1 As Col
INTO #temp1
INSERT INTO #temp1
SELECT 2 As Col
SELECT Col FROM #temp1
DROP TABLE #temp1
')
WITH RESULT SETS (
( Col int )
)0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive