Follow the same steps as above, but in the Upload File popup, select Google Drive.
1
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
2
Navigate to Dataset creation
Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.
3
Select Google Drive
In the Upload File popup, select Google Drive.
4
Log in to Google account
Log in to the Google account that contains the file you want to upload.
5
Grant access to FPT Data Suite App
Grant access to the FPT Data Suite App (Trust DS App).
6
Select file and upload
Select the file > Upload.
7
Double-check the uploaded file
Double-check the uploaded file before proceeding.
Upload Files from OneDrive
Follow the same steps as above, but in the Upload File popup, select OneDrive.
1
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
2
Navigate to Dataset creation
Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.
3
Select OneDrive
In the Upload File popup, select OneDrive.
4
Log in to OneDrive account
Log in to the OneDrive account that contains the file you want to upload.
5
Select file and upload
Select the file > Upload.
6
Double-check the uploaded file
Double-check the uploaded file before proceeding.
Create Dataset from a CSV File
1
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
2
Navigate to Dataset creation
Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.
3
Select file source
Select one of the three file sources (From computer, Google Drive, or OneDrive).
4
Select and upload file
Select your CSV file and upload it.
5
Complete the dataset creation
Complete the dataset creation process.
Create Dataset from an Excel File or Google Sheets
1
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
2
Navigate to Dataset creation
Navigate to Workspace > Data Warehouse > Create Dataset > From new file > Browse.
3
Select and upload file
Select an Excel file or a Google Sheets file and upload it.
4
Configure additional settings
Additional settings:
Select a sheet.
Select the data range (cell range) to import into the Data Warehouse.
Note: By default, the first row of the file (CSV, Excel, or Google Sheets) is used as the header. Dataset field names are based on these headers.
Create Dataset from an Existing File
1
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
2
Navigate to Dataset creation from available file
Navigate to Workspace > Data Warehouse > Create Dataset > From Available File.
3
Select file
Select a file from the list of previously uploaded files.
4
Complete dataset creation
Follow the instructions to complete dataset creation.
Synchronize Data from File to DWH Table
When you need to modify data (update, add, or delete) in a Dataset that was originally created on the DWH from a file source, you'll need to update and synchronize this data to the DWH.
Note: When updating a file, do not modify its structure—only update its content.
You can:
Update the file locally (on your computer), or
Update it directly on Google Drive or OneDrive (if it was originally uploaded from there).
Do not change the file structure (e.g., column names or number of columns).
Any structural modifications—such as adding, removing, or renaming columns—will cause synchronization errors.
For Files from Computer
1
Update the file content locally
Update the file content on your computer.
2
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
3
Navigate to Dataset's Data Origin
Navigate to: Workspace > Data Warehouse > [Dataset] > Data Origin.
4
Upload the updated file
Upload the updated file from your computer, Google Drive, or OneDrive.
5
Complete the Dataset file information update
Complete the process of updating the Dataset file information.
6
Synchronize data from source
Go to the Data tab > select Update data from source.
For Files from Google Drive or OneDrive
1
Update the file directly on Drive/OneDrive
Update the file content directly on Google Drive or OneDrive.
2
Log in to FPT Data Suite
Log in to the FPT Data Suite system.
3
Synchronize data from source
Navigate to: Workspace > Data Warehouse > [Dataset] and click Update Data from Source.
