Hi Cristiano, Take a look on Nifi processor PutDatabaseRecord wich can read from a csv source (and others json, avro,ect) and put the records on a existent table on database. If you need to create a table based on the schema of CSV you probably need a custom script, take a look in this post: https://stackoverflow.com/questions/49053901/create-a-postgresql-table-from-avro-schema-in-nifi/49076714#49076714.
Carlos From: Cristiano Silva [mailto:[email protected]] Sent: 2 de maio de 2021 20:40 To: [email protected] Subject: CREATE TABLE code is generated automatically from csv. *** ATENÇÃO: esta mensagem de e-mail tem origem externa! A cibersegurança é uma responsabilidade partilhada. Não aceda a links nem anexos de mensagens suspeitas ou inesperadas. CSIRT CGD *** ________________________________ Hello, I hope you are well. Please, I would like to know how do I create a table from a csv. I read the csv and a CREATE TABLE code is generated automatically, according to the elements that were found in the first 10 (100, 1000, etc ...) lines. Thank you very much! Atenciosamente, Cristiano Luís Turbino de França e Silva ============================== GNU / Linux , , / .-. / \ / (e e) ((__-^^-,-^^-__)) / _.`V'._ `-_---' `---_-' / //~~W~~\\ <__|o ` 'o|__> / //, ,\\ \ ` / / // | | \\ ): :( / \) | | (/ :o_o: / \ / "-" / `w - w'
