Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: added in easy excerpts and fixed some bad grammar

...

  • Business: you must specify a domain, relative path, and folder path.

  • Personal: you must specify the folder path and whether it is a shared folder or not.

...

Compression: indicate whether the result is to be compressed or not. Available optionsOptions: None, gz, and bzip2.

Header line: select if the exported data has the column name as the header line.

...

Code Block
linenumberstrue
SELECT email, first_name, last_name, region, age, gender, website FROM (
 VALUES ('kate1@gmail.com', 'Kate', 'Tiny', 'Asia', '41 and above', 'female', 'google.com'),
 ('ronan@gmail.com', 'R', 'P', 'Americas', '21-30', 'male', 'google.com'),
 ('michelle@gmail.com', 'M', 'C', 'EMEA', '31-40', 'male', 'facebook.com')
) tbl (email, first_name, last_name, region, age, gender, website);

...



Optionally Schedule the Query Export Jobs

You can use Scheduled Jobs with Result Output, Export to periodically write the output result to a target destination that you specify.

...

Numbered Headings
start-numbering-with1
start-numbering-ath5

Excerpt Include
PD:Scheduling Jobs Using TD Console
PD:Scheduling Jobs Using TD Console
nopaneltrue


Optionally Configure Export Results in Workflow

Within Treasure Workflow, you can specify the use of this data connector to output data.export data.

Learn more at Using Workflows to Export Data with the TD Toolbelt.

Example Workflow for OneDrive


Code Block
linenumberstrue
timezone: UTC

_export:
  td:
    database: sample_datasets

+td-result-into-one-drive:
  td>: queries/sample.sql
  result_connection: your_connection_name
  result_settings:
    refresh_token:
    account_type:
    replace_existing:
    file_name:
    folder_path:
    domain_name:
    server_relative_path:
    is_shared_folder:
    replace_existing:
    format:
    compression:
    header_line:
    null_string:
    newline:
    quote_policy:

Select here for more information on using data connectors in the workflow to export data.


Use the CLI to Create Your Connection

...

Input the folder path param as shown: folder_path: /f1/f2 (note: folder f0 is not shared with you)


Q: How can I export

...

files to a SharePoint

...

collection?

You need a Domain Name, server Relative Path, and Folder Path to import files from SharePoint collections. See Domain Name and Relative Path

...

Open the folder that you want to import on the browser. Then get the Domain Name and Relative Path as shown:

Personal folder

Image Modified


SharePoint collection


Folder shared with me

Image Modified


Get Your Own refresh_token

...

From Request API permissions window, select Microsoft Graph -> Delegated permissions and add permissions as shown:

Image Modified


From the Certificates & secrets tab, select on New client secret, select Never and Add.

Image RemovedImage Added


A new client secret key is created as shown:

Image Modified


From the Overview tab, you see the client id as shown:

...

Accept the Permission Request window.

Image RemovedImage Added


Copy the code from the address bar:

...