https://community.databricks.com/t5/data-engineering/how-to-export-full-result-databricks-azure/m-p/24495#M17030 <P>Yes, databricks display only a limited dataframe. It allows you to download the data like a csv, . You can save the dataframe as a table in the databricks database with this:</P><PRE><CODE>predictions.select("salry", "dept").write.saveAsTable("depsalry")</CODE></PRE><P></P><P>Then you can load it with:</P><PRE><CODE>predictions = spark.table('predictions')</CODE></PRE><P></P><P></P> Tue, 15 Jun 2021 15:50:49 GMT User16826994223 2021-06-15T15:50:49Z https://community.databricks.com/t5/data-engineering/how-to-export-full-result-databricks-azure/m-p/24494#M17029 <P>what is the best way to see all the data , I see display shows up to 100000 data only . any way in which I can see all the data or do I need to download or export it in different file </P> Tue, 15 Jun 2021 15:49:56 GMT https://community.databricks.com/t5/data-engineering/how-to-export-full-result-databricks-azure/m-p/24494#M17029 User16826994223 2021-06-15T15:49:56Z https://community.databricks.com/t5/data-engineering/how-to-export-full-result-databricks-azure/m-p/24495#M17030 <P>Yes, databricks display only a limited dataframe. It allows you to download the data like a csv, . You can save the dataframe as a table in the databricks database with this:</P><PRE><CODE>predictions.select("salry", "dept").write.saveAsTable("depsalry")</CODE></PRE><P></P><P>Then you can load it with:</P><PRE><CODE>predictions = spark.table('predictions')</CODE></PRE><P></P><P></P> Tue, 15 Jun 2021 15:50:49 GMT https://community.databricks.com/t5/data-engineering/how-to-export-full-result-databricks-azure/m-p/24495#M17030 User16826994223 2021-06-15T15:50:49Z