Template - Dynamic in-db field

[#1]

1. Challenge: We create several standarized in-db macros for our users. They are intended to let users not need to build star schema SQL each time they connect.

The issue we had we the "list box" tool to select fields, is that is did not support in-db. We wanted a solution where if we select fields on the macro, then the rest of the workflow is aware of which fields are selected.

2. Solution: How does your workflow, app, package, etc. solve the challenge?

By adding 6 tools at the end of our macros, we solved a working dynamic select tool.

3. Value: 

3.1 Users save time in not having to open the query builder

3.2 We have standarized how users should connect to verified data sources.

Here we select fields with the in-db macro: 

And the following select tool is aware that "amount" is no longer available.

To test this, i have created 2 dummy tables with a select statement, preview:

SELECT *
FROM (VALUES
  (1, 'alpha', 10.5),
  (2, 'beta',  20.0),
  (3, 'gamma', 30.25)
) AS t(id, name, amount)

Requirement: You will need to fill in a path to working indb odbc file to test this.