how can I link a dataset to all the tables in a database - using a SQL federated connection
If I have a valid federated connection - that I can browse all the tables - how do I link a dataset to all the tables? (I've done it once apparently - but now I can't figure out how to do it again)?
Every option I come up without only lets me select one table at time - and that can't be right… I've got o be doing something stupid and missing something simple….
Answers
-
Microsoft SQL Server by the way
0 -
Ugh - and I just realized these datasets are really only 1:1 tables or views - so can't really do what I'm asking . 🤯
0 -
Never mind - literally got it after I posted this. Apparently - I hadn't used the variable anywhere on a card….. althought it existed - and was used in a calculation - that calculation wasn't actually "used" in any visualization or filter or anything. Once I used it (which honestly was a mistake - not on perhaps) - the variable showed up to select on other card.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive