Cmdlets for Asana

Build 20.0.7654

Tables Parameter (Connect-Asana Cmdlet)

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.


Connect-Asana -Tables string


Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the cmdlet.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654