Hi,- I have a scenario to load a table with close to 100 million records from MSSQL server(on-premise) to Bigquery in GCP. I am using tap-mssql extractor and target-bigquery loader(default variants). Can you tell me settings/configurations which need to be set in both extractor ad loader in meltano.yml to complete the data load fast and in an efficient manner ?

The buzzcutnorman variant and the default target-bigquery support BATCH mode, so you might want to give that a try: https://sdk.meltano.com/en/latest/batch.html#batch-configuration