Create Data Source Query

Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.

Create Data Source Query. ProviderSQLOLEDB1Initial CatalogXXXData SourceYYYUse Procedure for Prepare1Auto TranslateTruePacket Size4096Workstation IDRRRRTag with column collation when possibleFalse Query 1- Select DISTINCT baccount_name as Account bmarket_segment_id baccount_type_id. On the data source page in the canvas double-click the custom SQL query in the logical layer.

How To Pull Data From Google Spreadsheets In Redash And Create Chart Google Spreadsheet Business Analyst Data
How To Pull Data From Google Spreadsheets In Redash And Create Chart Google Spreadsheet Business Analyst Data from in.pinterest.com

Press the Get Data button found in the Get Transform Data section of the Data tab. You may also select a existing data source. Click Data Sources in the left navigation bar.

On the data source page in the canvas double-click the custom SQL query in the logical layer.

Select Blank Query in the menu. It is important to use the Showcase driver since it supports Showcase security and many Showcase functions including dates and JDE integration Click Finish. If you arent using the default data source for this data set select the Data Sourcefrom the list. It turns out the way to query a query is to create a Blank Query and then reference your query as a source.