Support Questions

Find answers, ask questions, and share your expertise

Need to get Table schema from database using nifi processor

avatar

The problem is need to fetch the table schema for a table. Then after fetching the schema, I need to build the select query from the schema.This is because, it should work any table with any number of columns.

The idea is to build a generic processor to extract records from a table, irrespective of table schema. Instead of desiging different workflows for different table.

10 REPLIES 10

avatar

@pranayreddy bommineni

You can add limit 1 to your SQL query with ExecuteSQL to get only one row for schema inference