Prophet always expects two columns in the input DataFrame: ds and y . The ds column represents the date from your SQL query, and needs to be either date or datetime data type. The y column represents the value we are looking to forecast, and must be of numeric data type.