Use when setting up impersonation on the server. The user name and domain of the current server user. Returns an empty string if the user is not signed in to Tableau Server. The user name of the current server user. The following parameters are supported in an initial SQL statement: Parameter You can provide more details in logging, for example, the Tableau version or the workbook name. If your data source supports it, you can set up row-level security (for example, for Oracle VPD or SAP Sybase ASE) to make sure that users see only the data that they are authorized to see. You can configure impersonation using the TableauServerUser or TableauServerUserFull parameters. There are several reasons why this is useful: You can pass parameters to your data source in an initial SQL statement. Workbook opens, but the initial SQL commands are not sent.įor more information about the tsm configuration set command, see the Tableau Server Help (Link opens in a new window). If the server doesn't allow initial SQL statements, the Is configured to allow these statements to run when the workbookĪdministrators can configure server to ignore initial SQL statements by using the tsm configuration set command: If you publish to Tableau Server, the server must be configured May restrict you from using initial SQL with your connection. You can use the Insert drop-down menu to pass parameters to your data source. Or, on the Data Source page, select Data > Initial SQL or Data > Query Banding and Initial SQL depending on the database you connect to.Įnter the SQL command into the Initial SQL dialog box. In the Server Connection dialog box, click Initial SQL. For information about your data source, see Supported Connectors. Note: If your data source supports running an initial SQL statement, an Initial SQL link appears in the lower-left corner of the Server Connection dialog box. You have the option to add an initial SQL command in the Server Connection dialog box or on the Data Source page. For more information, see Connect to a Custom SQL Query. A custom SQL connection defines a relation (or table) to issue queries against. Note that this initial SQL is different than a custom SQL connection. Initial SQL is not run when your refresh your view. When connecting to some databases, you can specify an initial SQL command that will run when a connection is made to the database, for example, when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. For information about using Initial SQL with Tableau Prep Builder, see Use Initial SQL to query your connections (Link opens in a new window) in the Tableau Prep Builder online help. Note: Tableau Prep Builder version 2019.2.2 and later supports using Initial SQL, but doesn't yet support all of the same options supported by Tableau Desktop.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |