Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As needed, the platform can be configured to ingest data from your relational datasources to the base storage layer for faster execution of Spark-based jobs. See Configure JDBC Ingestion.

Append userId to logged queries

Info

NOTE: This feature may be available via Hot Fix only. Please contact 

D s support
.

Optionally, you can choose to enable appending the

D s item
itemuser identifier
as a comment to the SQL queries that are written to your database logs. Example:

Code Block
execute <unnamed>: SELECT * FROM "public"."artifacts" LIMIT 10 /* userId: 1 */

In the above, the

D s item
itemuserId
(1) is written in the comment.

These types of queries are logged for the following basic activities:

  • Data preview: when previewing data from a relational source, a query is executed against the database
  • Data import: when selecting a table to import
  • Data import using custom SQL:
    • Click Validate button.
    • Custom SQL execution.

This feature enables auditing of

D s item
itemuser activities
through your database logs.

Steps:

  1. D s config
  2. Locate the following setting and set it to true:

    Code Block
    "feature.addUserIdToSQLQuery.enabled": false,


  3. Save your changes and restart the platform.

Configure Security

For more information, see Configure Security for Relational Connections.

...