def get_platform_and_table(view_name: str, connection: str, sql_table_name: str):
	"""
	This will depend on what database connections you use in Looker 
	For SpotHero, we had two database connections in Looker: "redshift_test" (a redshift database) and "presto" (a presto database)
	Presto supports querying across multiple catalogs, so we infer which underlying database presto is using based on the presto catalog name
	For SpotHero, we have 3 catalogs in presto: "redshift", "hive", and "hive_emr"
	"""
	if connection == "redshift_test":
		platform = "redshift"
		table_name = sql_table_name
		return platform, table_name

	elif connection == "presto":
		parts = sql_table_name.split(".")
		catalog = parts[0]

		if catalog == "hive":
			platform = "hive"
		elif catalog == "hive_emr":
			platform = "hive_emr"
		elif catalog == "redshift":
			platform = "redshift"
		else:
			# Looker lets you exclude a catalog and use a configured default, the default we have configured is to use hive_emr
			if sql_table_name.count(".") != 1:
				raise Exception("Unknown catalog for sql_table_name: {sql_table_name} for view_name: {view_name}")

			platform = "hive_emr"
			return platform, sql_table_name

		table_name = ".".join(parts[1::])
		return platform, table_name
	else:
		raise Exception(f"Could not find a platform for looker view with connection: {connection}")