Contents x
      InjectTables
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      InjectTables

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      PROTOTYPE

      Injects shared tables (and joins) from a source project into another project.

      KeyValue(s)Description
      method"InjectTables"Injects shared tables (and joins) from a source project into another project.
      sourceProject"NameOfSourceProject"Required. The project containing the source tables.   Must exist and must be on the same realm as the target project.
      targetProject"NameOfTargetProject"Required.  The project to receive the injected tables.  Must exist and be on same realm as the source project.
      project"ActiveProjectName"
      sourceTables[][
      "sTable1",
      "sTable2",
      "*"
      ]      		Required.
      List of tables to inject.   To inject all tables from the source project, use "*" and remove the targetTables parameter.
      targetTables[][
      "tTable1",
      "tTable2",
      "*"
      ]      		Required. 
      Names of tables to inject.   Number of tables must match number of tables in sourceTables, and order must match.   e.g., sTable1 -> tTable1, sTable2 -> tTable2 etc
       
      includeJoinstrue/falseIf true, all joins between tables in sourceTables[] list will be imported.  If false, no joins will exist between injected tables.

      Notes on injected Tables:

      • Source and Target Projects must be on the same realm
      • Deleting the Source Table in the Source Project will delete the Target Table in the Target Project
      • Source Table Fields cannot be altered in the target project - source-table fields are displayed in green.
      • Source Table Fields cannot be deleted in the target project - attempting to do so will give "Error deleting field. permission denied (1008)"

      See Also:


      {
  "method": "InjectTables",
  "project": "test",
  "sourceProject": "DataSource_01",
  "sourceTables": [
            "Customers", 
            "Transactions" 
            ],
  "targetTables": [
            "Cust_DS01", 
            "Trans_DS01" 
            ],
  "targetProject": "AllDataSource_01",
  "includeJoins": true
}


      Was this article helpful?
      What's Next