Renta / Docs / Sources / File

File

Renta exports remote CSV files directly to your data warehouse: you provide the file URL, and Renta reads the file headers and loads the selected columns into the destination table. If the file is protected, Renta authenticates using Basic authorization before extracting the dataset.

Authentication

Renta supports downloading flat files via a direct URL. If your file is protected from public access, you can use Basic authorization.

Connect File source

Follow these steps to add a File source in Renta.

Go to the CatalogStep 1

Navigate to the Connections > Catalog section in the left sidebar, find and select File.

Renta Catalog
Add sourceStep 2

Click + Add source to start configuring your connection.

Add File source
Set File typeStep 3

Provide the direct File URL to your dataset. Currently, Renta supports extracting CSV files.

Select File type
Choose Authorization typeStep 4

Select the required authorization method:

  1. No authorization.
    For publicly accessible file URLs.
  2. Basic authorization.
    For files secured with a username and password.
Select Authorization type
Configure Basic authorizationStep 5

If you selected Basic authorization, provide the Login and Password required to access the file.

Basic authorization
Configure connectionStep 6
  1. Source name.
    A display name for this connection in Renta.

Click Save to finish.

Name and save connection
Source createdStep 7

Your file source is now connected and ready to be used in a pipeline.

Source successfully created

Pipeline configuration

When creating a pipeline with the File source, configure how Renta reads and transfers the dataset.

Create data pipeline

Set up your data flow from the File source to the data warehouse.

Select sourceStep 1
  1. Source.
    Choose File from the available source types.
Select File source
Select connectionStep 2
  1. Connection.
    Select the File connection you created earlier.
Select File connection
Select destinationStep 3
  1. Destination.
    Choose the data warehouse where you want to load the file data.
Select destination
Select destination connectionStep 4
  1. Destination connection.
    Select your specific destination account.
Select destination connection
Set Table nameStep 5
  1. Table name.
    Set the destination table name. The data will be loaded here.
Set Table name
Configure ParametersStep 6
  1. Contains headers.
    Toggle this on if the first row of your CSV file contains column names.
  2. Parameters.
    Select the columns you want to sync. Renta reads the file header to populate this list.
Configure Parameters
Update timeStep 7
  1. Update time.
    Choose the time when Renta should run the pipeline.
Configure update time
Review ScheduleStep 8
  1. Schedule.
    Set the frequency for the automated runs.
Review Schedule
Pipeline createdStep 9

Click Save. Your pipeline is ready and will execute on the defined schedule.

Pipeline successfully created

Sync strategy

The table below describes how Renta synchronizes the File source.

StrategyDescription
Full reloadFlat files lack a native modification-date field for incremental tracking. Renta reloads the entire file during each run and fully overwrites the destination table to match the current state of the source file.

Ready to get started?

Build your data pipeline today or get a personalized demo. Start free!

Need help?

Get expert support to ensure your project succeeds. We're here to help!

Feature requests?

Help shape our product! Share your ideas for new features and integrations.