title: pyspark load dataframe in bigquery from local
body: <p>I want to load a pyspark dataframe into a Google BigQuery table.</p>
  
  <p>I run the job by running</p>
  
  <pre><code>spark-submit --jars batch/jars/gcs-connector-hadoop2-latest.jar,batch/jars/spark-bigquery-latest.jar main_batch.py
  </code></pre>
  
  <p>I think I've set all the required configs:</p>
  
  <pre><code>sc = SparkSession\
          .builder\
          .config("temporaryGcsBucket", "test_project_bucket_pyspark") \
          .config("fs.gs.impl", "com.google.cloud.hadoop.fs.gcs.GoogleHadoopFileSystem")\
          .config("fs.gs.auth.service.account.enable", "true") \
          .config("google.cloud.auth.service.account.json.keyfile", "config/google/service_account_project.json") \
          .master("local[1]")\
          .appName("spark_etl")\
          .getOrCreate()
  </code></pre>
  
  <p>And I'm running this for saving into BigQuery:</p>
  
  <pre><code>df.write \
          .format("bigquery") \
          .option('table', 'dataset_project_test.tickets') \
          .option("encoding", "UTF-8") \
          .option("nullValue", "\u0000") \
          .option("emptyValue", "\u0000") \
          .mode("append") \
          .save()
  </code></pre>
  
  <p>But I receive the following error:</p>
  
  <pre><code>py4j.protocol.Py4JJavaError: An error occurred while calling o1176.save.
  : java.io.IOException: No FileSystem for scheme: gs
  </code></pre>
  
  <p>What I'm doing wrong? Thank you</p>