title: Is it possible to use Cloud Data Fusion FTP -> GCS -> BQ
body: <p>I am brand new to GCP and Cloud Data Fusion. I see that you can use this service to integrate data across data sources into a data lake.</p>
  <p>I have a number of sftp providers offering files in different structured formats eg. csv, json, parquet, and avro</p>
  <p>Ultimately I'd like this data to be available in BQ.</p>
  <p>Before loading to BQ my first stop was going to be Google Cloud Storage, that way I have an immutable copy of the data.</p>
  <p>The sftp site will have multiple files representing multiple tables.</p>
  <pre><code>/root/table_1
  /root/table_2
  /root/table_3
  </code></pre>
  <p>I'm first trying to see if I use a Cloud Data Fusion pipeline to copy the files from SFTP to GCS. This has proven to be challenging.</p>
  <ol>
  <li>Can I use Fusion for this?</li>
  <li>Do I need to provide the schema for each file or can it be inferred?</li>
  <li>Do I need to manually enumerate every table? Ideally I'd like to copy all the files as is from SFTP to GCS</li>
  <li>Once in GCS I'd like to make an external data source in BigQuery for each file. Is that possible?</li>
  </ol>