Begin by logging into your Freshsales account. Navigate to the data management or export section. Select the type of data you need to export (e.g., contacts, leads, deals). Choose a suitable format for export, typically CSV or Excel, which can be easily managed and transformed later. Initiate the export and download the file to your local system.

Open the exported file and review the data structure. Identify the fields and data types to ensure compatibility with Firebolt's schema requirements. Clean the data if necessary, removing any duplicates or unwanted entries. Ensure that the data is in a consistent format, as this will make the transformation process smoother.

Firebolt requires structured data, typically in a tabular format. Using tools like Python Pandas or even Excel, transform the data to match Firebolt's schema. This might involve renaming columns, changing data types, or reorganizing the data structure to fit the Firebolt database design. Ensure that the transformed data adheres to any constraints or requirements set by Firebolt.

Access your Firebolt account and ensure you have the necessary permissions to create and manage tables. Create a new database or use an existing one where the data will reside. Define the schema within Firebolt that matches the transformed data structure. This involves setting up tables with the appropriate columns and data types.

Use Firebolt's native data loading capabilities to ingest the prepared data. This can typically be done using Firebolt's SQL interface. Write a SQL query to load the data from your CSV or transformed file into the appropriate table in Firebolt. Ensure that the data types and order of columns in your file match those defined in the Firebolt schema to avoid errors during loading.

Once the data is loaded, perform checks to validate the integrity and accuracy of the data within Firebolt. Run SQL queries to verify row counts, check for any anomalies or mismatches in data types or values. Compare a sample of the original data from Freshsales with the data now in Firebolt to ensure consistency.

After confirming that the data is correctly loaded, optimize the database for performance. This involves creating indexes if necessary, partitioning tables to improve query performance, and possibly restructuring the data for better analytics performance. Firebolt provides tools and documentation to help with database optimization, so refer to those resources to fine-tune your setup.

By following these steps, you can successfully move data from Freshsales to Firebolt without relying on third-party connectors or integrations.