Agent Remote Import Table into SQL Database
Description
Section titled “Description”Pushes a PlaidCloud project table into a database that’s reachable only through a PlaidLink Agent. The Agent receives the data from PlaidCloud and performs the load locally — useful for keeping an on-premises operational database in sync with PlaidCloud analytics.
Typical use: PlaidCloud produces a refreshed forecast or allocation result and the Agent loads it into the on-premises ERP, data mart, or operational reporting database.
How the Data Reaches the Agent
Section titled “How the Data Reaches the Agent”A PlaidLink Agent on version 1.2.33 or later receives the table’s rows as one Parquet file. Numbers, dates, timestamps and true/false values arrive as their own types. Other columns, such as time, interval and JSON columns, arrive as text. An empty text value arrives empty (NULL), as it always has.
An older Agent receives the rows as a zipped tab-delimited file, as before. Upgrade the Agent to receive Parquet.
Examples
Section titled “Examples”No examples yet…