As mentioned by @Gord Thompson in comment, the above error will be solved by the below code.

sample_table = Table( 
      'file_downloads', 
       meta_data, 
       schema=f"{schema}.{dataset}", 
       autoload_with=engine 
)

Posting the answer as community wiki for the benefit of the community that might encounter this use case in the future.

Feel free to edit this answer for additional information.