In the Table Output component, what occurs if the database connection is lost while records are being written? How does the pipeline handle partially written data?

In the Table Output component, what is the difference between Match by Position and Match by Name when mapping incoming pipeline columns to target table columns?

In the Table Output component, how does the Append mode behave when duplicate records are written to the target table? Does it prevent duplicates automatically?

When using the Table Input component, are there limitations on the type of SQL queries that can be executed (for example, only SELECT)? Why are certain query types not allowed?

In the Table Input component, why must a filter condition be enabled when using Change Data Capture (CDC)? What problem occurs if CDC is configured without a filter?

Can users create multiple grouped conditions using AND/OR logic?

Is it possible to restrict the project access to user in Data Magnet?