From the course: Data Management with Apache NiFi
Join today to access over 24,400 courses taught by industry experts.
Creating a PostgreSQL table, Amazon S3 bucket, and an IAM user - Apache NiFi Tutorial
From the course: Data Management with Apache NiFi
Creating a PostgreSQL table, Amazon S3 bucket, and an IAM user
- [Instructor] In this demo, we'll set up an even more involved data flow using Apache NiFi. We'll have this data flow read data from our local file system, place data into a PostgreSQL database table. We've already seen this part. Then we'll read from the database table and filter the records and store filtered records out to an Amazon S3 bucket. We'll have to do a little bit of setup before we run our data flow. Here, I am logged into psql. I'm going to create a new database called laptops_db. This is the database under which we'll create a table called laptops, and we'll store laptop records in this table. Let's connect to this laptops_db using \c. Now that we're connected, we can create a new table under here. Here's what the laptops table looks like, ID, company, product, TypeName, and price in euros. Go ahead and create this table, and let's confirm that this table does indeed exist. I'm going to run \dt,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
